/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80034 (8.0.34)
 Source Host           : localhost:3306
 Source Schema         : librarydata

 Target Server Type    : MySQL
 Target Server Version : 80034 (8.0.34)
 File Encoding         : 65001

 Date: 11/08/2023 18:55:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_book
-- ----------------------------
CREATE TABLE `t_book`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `num` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 155 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_book
-- ----------------------------
BEGIN;
INSERT INTO `t_book` (`id`, `name`, `num`) VALUES (3, '2023/7/28', 9999999), (5, '建筑专业20', 13), (10, '艾莉丝·格雷拉特', 99), (80, '德鲁乌斯', 100), (109, '苦海无涯,回头无岸', 156), (124, '布莱恩·安格劳斯', 64), (125, 'OverLodeⅠ', 100), (126, 'OverLodeⅡ', 100), (127, 'OverLodeⅢ', 100), (129, 'GB50037建筑防火指南通用规范', 5), (130, 'GB50036消防安全指南通用规范', 5), (131, '市政定额', 1), (132, '通用定额', 12), (133, '建筑专业一', 3), (134, '建筑专业二', 2), (135, '建筑专业三', 1), (136, '建筑专业四', 10), (137, '建筑专业五', 30), (138, '建筑专业六', 25), (139, '建筑工程管理实务', 83), (140, '公路工程管理与实务', 995), (141, '水利水电工程管理与实务', 12), (142, '市政公用工程管理与实务', 98), (143, '机电工程管理与实务', 15), (144, '建设工程经济', 78), (145, '建设工程项目管理', 69), (146, '建设工程法规及相关知识', 97), (147, '建设工程经济复习题集', 15), (148, '建设工程项目管理项目管理复习题集', 49), (149, '公路工程管理与实务复习题集', 79), (150, '矿业工程管理与实务复习题集', 51), (151, '市政公用工程管理与实务复习题集', 69), (152, '机电工程管理与实务复习题集', 64), (153, '建设工程经济复习题集', 15), (154, 'ok第一个较为完整的系统做完了', 999);
COMMIT;

-- ----------------------------
-- Table structure for t_lend
-- ----------------------------
CREATE TABLE `t_lend`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NULL DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `book_id` int NULL DEFAULT NULL,
  `book_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `book_num` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6301017 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_lend
-- ----------------------------
BEGIN;
INSERT INTO `t_lend` (`id`, `user_id`, `user_name`, `book_id`, `book_name`, `book_num`) VALUES (6301000, 2022030200, '张三', 3, '2023/7/28', 1), (6301001, 2022030216, '李四', 10, '艾莉丝·格雷拉特', 1), (6301002, 2022030200, '张三', 125, 'OverLode Ⅰ', 1), (6301003, 2022030200, '张三', 125, 'OverLodeⅡ', 1), (6301005, 2022030216, '李四', 127, 'OverLode Ⅲ', 1), (6301014, 2022030216, '李四', 139, '建筑工程管理实务', 1), (6301015, 2022030216, '李四', 3, '2023/7/28', 1), (6301016, 2022030216, '李四', 3, '2023/7/28', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
CREATE TABLE `t_user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `age` int NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `password` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2022030220 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`id`, `name`, `age`, `sex`, `user_name`, `password`) VALUES (2022030200, '张三', 18, '男', 'admin', 123456), (2022030202, '王五', 20, '男', 'power', 123456), (2022030205, '赵六', 19, '女', 'user', 123456), (2022030206, '秘名函数', 15, '男', 'ihsdfwe', 123456), (2022030215, '秘名函数', 20, '男', 'rooy', 123456), (2022030216, '李四', 20, '女', 'root', 123456), (2022030218, '秘名函数', 88, '男', 'osdiahf', 123456), (2022030219, '艾莉丝·格雷拉特', 15, '女', 'ailisi', 123456);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
